//
//  PlayerDataBase.h
//  WXMusic
//
//  Created by 漫步人生路 on 15/9/9.
//  Copyright (c) 2015年 漫步人生路. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "FMDatabase.h"
#import "FunPicModel.h"
#import "LatestJokeModel.h"
#import "FortunePaperModel.h"
@interface PlayerDataBase : NSObject
@property (nonatomic, strong) FMDatabase *dataBase;
//创建单例类
+ (PlayerDataBase *)shareDataBase;
//指定数据库路径
- (NSString *)sqlitePaths:(NSString *)sqlitePaths;
//打开数据库
- (void)openSqliteWithPaths:(NSString *)paths;
//关闭数据库
- (void)closeSqlite;
//建表
- (void)createTables;

//插入一条数据到表1
- (void)insertJokeModelToJokeTable:(LatestJokeModel *)model;
//获取表1所有数据
- (NSMutableArray *)selegetAllFromJokeTable;
//删除表1中数据
- (void)deleteJokesWithJokeName:(NSString *)content;

//插入表2数据
- (void)insertPicModelToPicTable:(FunPicModel *)model;
//获取表2数据
- (NSMutableArray *)selegetAllFromPicTable;
//删除表2数据
- (void)deletePicsWithPicName:(NSString *)content;

//插入表3数据
- (void)insertFortunePaperModel:(FortunePaperModel *)model;
//获取表3数据
- (NSMutableArray *)selegetAllFormFortunePapers;
//删除表3图片
- (void)deleteFortunePaperModelPath:(NSString *)path;







@end
